package com.maycurobj.repository.bpm;


import com.maycurobj.entity.bpm.JobNumberDTO;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;
import org.springframework.stereotype.Repository;


@Repository
public interface JobNumberMapper extends JpaRepository<JobNumberDTO, String> {
    /**
     * bpm用户id转换为工号
     * @param id
     * @return
     */
    @Query(nativeQuery = true, value= "select employeeNo from h_org_user where id=:id")
    JobNumberDTO getUserID(@Param(value = "id") String id);
}
